Business Systems Analyst 3 (N-IT) - First Tek, Inc.
Vancouver, WA 98666
About the Job
POSITION RESPONSIBILITIES
Note: All official drafts, documents, and recommendations, as listed below, must be reviewed, finalized, and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.
Works closely with engineering teams to identify and answer operational and reliability questions, to provide data-driven insights that support and inform broad strategic initiatives.
Drives the development of big data and data mining solutions to help BPA by enabling them to extract, analyze, and model data to solve previously unsolved problems of a complex and nuanced nature.
Introduces new analytical and predictive models and methodologies that serve to establish new best practices in operations.
Develops and recommends new solutions for data access, maximization, and utilization, and identifies trends and opportunities for future development.
Performs research to design and implement algorithms for extracting information from large quantities of raw data.
Performs independent studies and assessments to evaluate the effectiveness of new computational and storage technologies in comparison to current systems capabilities.
Provides visuals and executive summaries as a technical advisor to senior management and other stakeholders.
Interprets model output for impacted and interested operational parties and stakeholders.
Develops and applies appropriate testing and prototyping of programs.
Provides technical expertise on analytics that address BPA and industry-specific questions.
Creates procedural and technical documentation of models before handing over routine model running to reporting personnel.
Reviews analytics created by others, provides advice and consultation, and leads independent verification of results, when needed.
Facilitates coordination of data and selection of methodologies.
Facilitates gathering and analyzing information using standard tools and approaches to integrate data from multiple sources.
Clarifies business operations and functions and solve existing problems.
Performs and fixes complex SQL queries.
Creates data models to store program data.
Coordinates with Geographic Information System (GIS) program representatives.
Works closely with IT groups to coordinate current and future IT plans and activities, including coordination and technical assistance to facilitate specific development projects that involve the computing environment.
Marks documents and maintains filing system(s), files, emails, and records in accordance with compliance requirements. Shares and disperses documents only to appropriate personnel (those with a Lawful Government Purpose (LGP) to know). Marks and maintains all official records in accordance with the Information Security (INFOSEC) and Information Governance & Lifecycle Management (IGLM) standards and procedures. Validates official records are accurately maintained for auditing purposes.
REQUIREMENTS
Education & Corresponding Experience (required on matrix)
Bachelor's degree or higher education in mathematics, computer science, machine learning, statistical methods, or closely related field is required.
8 years of experience with the following is required:
Manipulating data sets
Using Web Services
Querying databases
Coding knowledge and experience with several languages
Developing data models and algorithms
Required Technical Skills & Experience (required on matrix)
Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
Demonstrated knowledge of computer languages including, but not limited to, Java, Visual Basic for Applications (VBA), and proficiency with Power Query Language (M) and SQL.
Demonstrated ability to customize elements of statistics, machine learning, optimization, signal processing, text retrieval, and natural language processing to analyze data and interpret results in order to solve problems of a complex nature.
Demonstrated ability to take vaguely defined goals and translate them to problems that can be addressed with data-driven analysis.
Demonstrated ability to communicate and present proposals, findings, and recommendations, both written and orally, to senior staff, executives, and external parties (e.g., representing BPA regionally such as to key stakeholders, customers, industry organizations, or regulators).
5 years of experience in the following:
Generating reports from various data repositories
Utilizing Excel, including pivot tables, charting, and reporting
Automating with VBA.
1 year experience using Power BI, including ability to write Data Analysis Expressions (DAX)
Preferred Skills & Experience (optional on matrix)
Knowledge of GIS and Asset Management Systems.
Experience with R and/or Python software product(s)
Energy/utility industry experience.
Additional Requirements (not required on matrix)
Valid U.S. Driver's License is required.
Note: All official drafts, documents, and recommendations, as listed below, must be reviewed, finalized, and approved / accepted by appropriate BPA manager or other federal personnel with the authority to do so.
Works closely with engineering teams to identify and answer operational and reliability questions, to provide data-driven insights that support and inform broad strategic initiatives.
Drives the development of big data and data mining solutions to help BPA by enabling them to extract, analyze, and model data to solve previously unsolved problems of a complex and nuanced nature.
Introduces new analytical and predictive models and methodologies that serve to establish new best practices in operations.
Develops and recommends new solutions for data access, maximization, and utilization, and identifies trends and opportunities for future development.
Performs research to design and implement algorithms for extracting information from large quantities of raw data.
Performs independent studies and assessments to evaluate the effectiveness of new computational and storage technologies in comparison to current systems capabilities.
Provides visuals and executive summaries as a technical advisor to senior management and other stakeholders.
Interprets model output for impacted and interested operational parties and stakeholders.
Develops and applies appropriate testing and prototyping of programs.
Provides technical expertise on analytics that address BPA and industry-specific questions.
Creates procedural and technical documentation of models before handing over routine model running to reporting personnel.
Reviews analytics created by others, provides advice and consultation, and leads independent verification of results, when needed.
Facilitates coordination of data and selection of methodologies.
Facilitates gathering and analyzing information using standard tools and approaches to integrate data from multiple sources.
Clarifies business operations and functions and solve existing problems.
Performs and fixes complex SQL queries.
Creates data models to store program data.
Coordinates with Geographic Information System (GIS) program representatives.
Works closely with IT groups to coordinate current and future IT plans and activities, including coordination and technical assistance to facilitate specific development projects that involve the computing environment.
Marks documents and maintains filing system(s), files, emails, and records in accordance with compliance requirements. Shares and disperses documents only to appropriate personnel (those with a Lawful Government Purpose (LGP) to know). Marks and maintains all official records in accordance with the Information Security (INFOSEC) and Information Governance & Lifecycle Management (IGLM) standards and procedures. Validates official records are accurately maintained for auditing purposes.
REQUIREMENTS
Education & Corresponding Experience (required on matrix)
Bachelor's degree or higher education in mathematics, computer science, machine learning, statistical methods, or closely related field is required.
8 years of experience with the following is required:
Manipulating data sets
Using Web Services
Querying databases
Coding knowledge and experience with several languages
Developing data models and algorithms
Required Technical Skills & Experience (required on matrix)
Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
Demonstrated knowledge of computer languages including, but not limited to, Java, Visual Basic for Applications (VBA), and proficiency with Power Query Language (M) and SQL.
Demonstrated ability to customize elements of statistics, machine learning, optimization, signal processing, text retrieval, and natural language processing to analyze data and interpret results in order to solve problems of a complex nature.
Demonstrated ability to take vaguely defined goals and translate them to problems that can be addressed with data-driven analysis.
Demonstrated ability to communicate and present proposals, findings, and recommendations, both written and orally, to senior staff, executives, and external parties (e.g., representing BPA regionally such as to key stakeholders, customers, industry organizations, or regulators).
5 years of experience in the following:
Generating reports from various data repositories
Utilizing Excel, including pivot tables, charting, and reporting
Automating with VBA.
1 year experience using Power BI, including ability to write Data Analysis Expressions (DAX)
Preferred Skills & Experience (optional on matrix)
Knowledge of GIS and Asset Management Systems.
Experience with R and/or Python software product(s)
Energy/utility industry experience.
Additional Requirements (not required on matrix)
Valid U.S. Driver's License is required.
Source : First Tek, Inc.