Job DescriptionAs a Data Analyst / BI SQL Developer on the Technology Metrics & Reporting team you willplay a critical role in the data investigation, wrangling, and visualization processes within our reportingdelivery pipeline. Working directly with our business and internal stakeholders you will be responsiblefor managing the reporting request intake process, scheduling and leading requirements gathering anddata onboarding sessions with various stakeholders, creating final reporting deliverables, and managingreport update and decommission requests.Designing and building modern data pipelines and data streams using Azure Data Factory.
Engineer and orchestrate data flows & pipelines using high quality, easily deployable,
repeatable and extensible codebases that ingest and integrate data from many disparate datasources in a cloud environment using a progressive tech stack. e.g. SQL, Logic Apps, AzureFunctions, ADLS, Parquet
Be able to write and perform SQL scripts to filter and join varied data sets for reporting or
querying purposes. Improve existing reporting, code, and procedures
Develop Power BI reports and dashboards that connect to various on- and off-premise data
sources, ensuring data is optimized.
Delivering data and reporting requirements to business users and investigating and resolving
reporting errors, data discrepancies and queries
Collaborating with team members to collect data and produce exception reports to cleanse
data at the origin.
Communicate effectively with internal teams and stakeholders both virtually and in-person,
including communication with both technical and non-technical team members
Creating and maintaining documentation that includes the design, requirements and user
manuals for the organization
Create, analyze and support the delivery of regular and ad hoc reports, suggesting
improvements and changes where necessary.
Monitoring of existing data feeds to ensure data integrity.
Proactive investigations into any data discrepancies or anomalies
Your responsibilities will include exploring the data available and looking for trends and
valuable analysis that might be useful for the team / Business.
Conduct unit testing and troubleshooting
Working hours: 10:00 am - 7 pm RO Time (Flexible can log in one hour earlier). - - No on-call or overtime
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] . To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .Skills and Requirements
Experience with Data Warehouses, including architecture, infrastructure components, ETL/ELT and reporting/analytic tools and environments
Building pipelines using MS Azure Data Factory
TSQL (Data aggregation, transformation, relational table joins, etc.)
Experience of building, enhancing and utilizing Data Warehousing through SQL, providing Data
Analytics, complex data queries and joins and subsequently use of Power BI to present the results
SQL, Power BI
SSRS knowledge
Problem solver, attention to detail, analytical, troubleshooter - Azure Storage Accounts
Microsoft Power Platform
On-Prem data Gateways and Data Flows. null
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].