Job Location: Dallas, TX
At Moss Adams, we champion authenticity. For us, that means fostering a culture of talented people who care—about you, about our clients, and about our communities. Here, you’ll work towards our mission of empowering others to embrace opportunity, growing as a leader along the way. Our firm’s size, middle-market clients, customized career paths, and supportive culture make this a reality. Join a values-driven firm where you’ll have fun while solving complex and interesting business challenges.
The Data Engineer functions as the technical support on the firm’s analytics and data visualization projects. This individual will help continue to build out the firm’s business intelligence reporting. This position required expertise in complex DAX development and data modeling. This role collaborates with other Data Engineers, SQL Developers, and with other IT resources. Strong customer service and experienced in working with business stakeholders to gather requirements preferred.
Individuals who thrive at Moss Adams exhibit the following success skills – Collaboration, Critical Thinking, Emotional Intelligence, Executive Presence, Growth Mindset, Intellectual Curiosity, and Results Focus.
Responsibilities:
- Design, develop and implement technical solutions in SQL environment (databases, SQL, data marts, integrations)
- Support data integrations
- Develop, construct, test and maintain architectures (databases and large-scale processing systems)
- Analyze data and identify gaps, data quality and integrity issues
- Develop visual reports in Power BI utilizing data from Tabular and Multi-dimensional cubes
- Maintain and develop queries and stored procedures using T-SQL
- Work in all aspects of development, design, reviews, troubleshooting and post-production issue resolution
- Follow SDLC and create and maintain required documentation of newly developed and refactored applications
Qualifications:
- Bachelor’s degree or equivalent experience required; emphasis in Computer Science, Computer Engineering or related field preferred
- Minimum of 1 year of related experience required; experience in a professional services environment preferred
- Skilled in SQL programming in T-SQL building stored procedures and jobs
- Proficient with large volume data integration/ETL; experience with SQL Server Integration Services (SSIS) including ability to configure SQL Server agent
- Experience identifying and mapping data elements across multiple systems
- Hands-on experience with Azure platform
- Knowledge of Power BI report visualizations, Data Analysis Expressions (DAX), Power Query (M), and Power BI data modeling
- Knowledge of data integration, quality and validation
- Knowledge of MDM, Data Warehouse/Data mart and relational database design
- Should possess sound knowledge of SDLC using Azure DevOps
- Excellent written and verbal communication skills and able to interact with multiple IT teams and business partners both formally and informally
- Self-motivated with the ability to work both independently and in a team environment
- Effective time management, ability to multi-task with changing priorities while continuing to provide exceptional client service
- Ability to travel as needed, approximately 5%
Moss Adams is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation, gender identity or any other characteristic protected by law.
Moss Adams complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact careers@mossadams.com.
Submit CV To All Data Science Job Consultants Across United States For Free