Role : Data Analyst /Power BI

Location: Dallas, TX

Both Webcam and In Person Interview Hybrid

Waste Management/Teknotrain

NOTE : Need local to TX Candidates ONLY with DL / State ID

Data Analyst needed to create and customize SSRS reports, analyze, clean and load SQL data for migration projects, and create Business Intelligence reports and dashboards.

ON SITE requirement - see below

Mgr agrees to initial Virtual IVs but reserves the option to request an IN PERSON IV if needed.

The selected candidate must be able to work IN PERSON (ON SITE) for the first full week (5 days) of the engagement-- then a minimum of one day a week ON SITE thereafter REQUIRED. The candidate must have access to broadband internet and a home office free from distractions to qualify for remote work. The candidate can optionally work in person if preferred.

Additional in-person days may be necessary for meetings with clients.

Parking is free at our facilities.

Must work independently or as part of a small team on projects.

Years of Experience: 4-6

Days on Site per week: 1-2

Day to day responsibilities

Initial workload will be heavily focused on creation of SSRS reports, utilizing mockups provided by a configuration team to customize standard vendor provided reports.

Working on ETL processes to clean and load data to on-prem and cloud databases, SQL Server scripting and querying, and Business Intelligence report creation are other likely duties.

The Data Analyst will work with other team members, department stakeholders, vendors, and partners in the design, development and implementation of reporting, integration and data analytics solutions.

Required Skills

• Expertise in designing, developing, and deploying SSRS reports.
• Proficiency with SQL Server
• Strong knowledge of SQL for querying relational databases
• Experience with complex queries, joins, subqueries, and data manipulation.
• Perform data analysis, data profiling, SQL coding/query tuning, data modeling, and data validation
• Work and partner with internal stakeholders to develop reports or address data access and visualization needs
• Experience in data modeling with strong and demonstratable data management skills

Desired Skills/Experience

• Power BI report development
• Experience with Azure data warehousing solutions
• Experience with Azure ETL (Extract, Transform, Load) processes and tools
• Experience with Microsoft Fabric
• Proficiency in scripting languages (e.g., Python, PowerShell) for automation and data manipulation.

Skill	Years Used	Last Used
Proficiency with SQL Server Required 5 Years	5	Current
Expertise in designing, developing, and deploying SSRS reports Required 4 Years	5	Current
Strong knowledge of SQL for querying relational databases Required 4 Years	5	Current
Experience with complex queries, joins, subqueries, and data manipulation Required 4 Years	5	Current
Perform data analysis, data profiling, SQL coding/query turning, data modeling, and data validation Required 4 Years	5	Current
Work with partner and internal stakeholders to develop reports or address data access and visualization needs Required 3 Years	4	2023
Experience in data modeling with strong and demonstratable data management skills Required 3 Years	5	Current
Power BI report development Highly desired 3 Years	4	2023
Experience with Azure data warehouse solutions Highly desired 3 Years	5	Current
Experience with Azure ETL (Extract, Transform, Load) processes and tools Highly desired 3 Years	5	Current
Experience with Microsoft Fabric Highly desired 1 Years	3	2021
Proficiency in scripting languages (e.g., Python, PowerShell) for automation and data manipulation. Desired 3 Years	3	2021

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.