Data Engineer Ii

This position is ON-SITE in Las Vegas, NV

Description:

Data Engineer II – Enterprise Analytics is assisting in designing, developing, and deploying data-driven solutions as part of Enterprise Analytics data strategy and goals. Data Engineer II – Enterprise Analytics is responsible for creating reliable ETLs and scalable data pipelines to support Analytics and BI environment (including modeling and machine learning, visualizations, reports, cubes & applications, etc.). Data Engineer II – Enterprise Analytics participates in data modeling and development of data models and data marts by interpreting business logic required to turn complex ideas into a sustainable value add processes.

Essential Duties & Responsibilities

• Collaborate with Enterprise Analytics BI Analysts and Data Scientists, and other business stakeholders to understand business problems and build/automate data structures ingested by analytics products (e.g.: reports, dashboards, cubes, etc.).

• Create BI solutions, including dashboards (Power BI) and reports (SSRS, Excel, and Cognos).

• Development of logic for KPIs requested by the business leadership.

• Troubleshoot existing and create new ETLs, SSIS packages, SQL stored procedures and jobs.

• Assist in Star and Snowflake modeling, creating dimensional models and ETL processes.

• Write an efficient SQL code for use in data pipelines and data processing.

• Drive data quality processes like data profiling, data cleansing, etc.

• Develop best practices and approaches to support continuous process automation for data ingestion and data pipelines.

• Use innovative problem solving and critical thinking approaches to troubleshoot challenging data obstacles.

• Test, optimize, troubleshoot, and fine-tune queries for maximum efficiency.

• Maintain existing and create new Microsoft Power Apps solutions (including but not limited to Power Apps, Power Automate, Power BI, Flows, etc.) according to business needs.

• Perform QA and UAT processes to foster an agile development cycle.

• Create documentation on table design, mapping out steps and underlying logic within data marts to facilitate data adoption with minimum guidance from the Enterprise Analytics management.

• Identify areas of improvement not just in owned work, but also other areas of the business.

• Mentor and train junior Data Engineers on best practices, query and ETL optimization techniques.

• Create and maintain daily, weekly, monthly, quarterly reports and dashboards.

• Consolidate fractured enterprise reporting into a standardized product for easy visualization and cross-departmental understanding.

• Create reporting structures that accurately link cross-departmental data, which allows for on demand delivery of ad-hoc reports.

• Safety is an essential function of this job.

• Consistent and regular attendance is an essential function of this job.

• Performs other related duties as assigned.

• Extensive knowledge of Microsoft Excel (Excel formulas, data wrangling, VBA macros, graphs, and pivot tables) is required.

• Excellent critical thinker and effective problem solver with creative solutions.

Experience Level:

Expert Level

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.