Technology Operations Engineer II

Technology Operations Engineer II

What You’ll Contribute

The Technology Operations Engineer II supports data-driven technology operations by designing, building, and maintaining SQL-centric data pipelines and models that power operational reporting, governance, and compliance insights.

What You’ll Do

• Support the implementation, maintenance, and optimization of reporting and analytics platforms, including Power BI datasets, dashboards, and semantic models.
• Design, develop, and maintain SQL-based ETL processes to extract, transform, and load data from operational systems into analytics-ready structures.
• Build and maintain relational and analytical data models (tables, views, aggregations) optimized for reporting and performance.
• Ensure data quality, reliability, and timeliness by monitoring ETL jobs, validating transformations, and resolving data issues.
• Publish curated SQL datasets for downstream consumption, including exporting data from SQL to Power BI.
• Partner with stakeholders to translate reporting and governance requirements into scalable SQL logic and data structures.
• Develop and maintain Power Automate flows to streamline operational processes, automate notifications, and support compliance and governance workflows.
• Monitor data pipelines, reports, and automated processes to ensure data accuracy, timeliness, and availability, proactively identifying and resolving issues.
• Partner with stakeholders to gather requirements and deliver operational metrics, delivery analytics, and governance reporting that support business and technology objectives.
• Maintain and enhance Azure DevOps (ADO) configurations, including custom fields, workflow states, and data integrations used for metrics and operational reporting.
• Develop and document standard operating procedures, data definitions, and reporting standards to ensure consistent and reliable analytics delivery.
• Assist with audit, risk, and compliance reporting by ensuring supporting data and automated controls are operating effectively.
• Provide operational support and guidance to end users, troubleshooting reporting or automation issues and coordinating resolution as needed.

The above information is intended to describe the general nature and level of work performed by employees assigned to this job; it is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees in this role.

What You Have

Minimum Qualifications

• Hands-on experience with SQL development, including complex queries, ETL logic, and performance tuning.
• Proven experience in data modeling (relational and reporting-focused schemas).
• Experience building and supporting data pipelines used for operational, governance, or compliance reporting.
• Working knowledge of Power BI sufficient to connect to SQL data, export datasets, and create basic visuals and DAX measures.
• Familiarity with Azure DevOps (ADO) data structures for metrics or operational reporting.
• Strong analytical and problem-solving skills with attention to data accuracy and consistency.
• Ability to document technical solutions and communicate effectively with technical and non-technical stakeholders.
• Strong organizational skills with the ability to manage multiple priorities.

Preferred Qualifications (Nice to Have)

• Bachelor’s degree in Computer Science, Information Technology, Data Analytics, or a related field.
• Experience in a technology reporting, analytics, or operations support role.
• Familiarity with IT service management concepts (e.g., incident, problem, or change management).
• Experience supporting audit, risk, or regulatory reporting through automated or data-driven solutions.
• Exposure to data governance practices, data quality management, or enterprise reporting standards.

Brooksource is an equal opportunity employer that does not discriminate on the

basis of actual or perceived race, color, creed, religion, national origin, ancestry,

citizenship status, age, sex or gender (including pregnancy, childbirth, lactation

and related medical conditions), gender identity or gender expression, sexual

orientation, marital status, military service and veteran status, physical or mental

disability, protected medical condition as defined by applicable state or local law,

genetic information, or any other characteristic protected by applicable federal,

state, or local laws and ordinances.

Benefits & Perks

Benefits & Perks: Brooksource offers competitive medical, dental, vision, Health

Savings Account, Dependent Care FSA, and supplemental coverage with plans that

can fit each employee’s needs. We offer a 401k plan that includes a company

match and is fully vested after you become eligible, paid time off, sick time, and

paid company holidays. We also offer an Employee Assistance Program (EAP) that

provides services like virtual counseling, financial services, legal services, life

coaching, etc.

Pay Disclaimer:

The pay range for this job level is a general guideline only and not a guarantee of

compensation or salary. Additional factors considered in extending an offer

include (but are not limited to) responsibilities of the job, education, experience,

knowledge, skills, and abilities, as well as internal equity, alignment with market

data, applicable bargaining agreement (if any), or other law.