What are the responsibilities and job description for the Data & Analytics Engineer position at Dexian?
Job Summary:
Dexian is seeking a Data & Analytics Engineer for an opportunity with a client located in Milwaukee, WI.
Responsibilities:
- Collaborating with cross-functional teams and other data professionals to define business goals and set parameters to measure analytics outcomes
- Working with data scientists and analytics to collect and clean data for analysis
- Designing data models, as well as, developing and maintaining data pipelines
- Creating and maintaining data storage systems
- Developing documentation for data pipelines and storage systems
- Developing software to implement data reporting
- Troubleshooting and debugging data system errors
- Embracing new technology and staying up to date with industry best practices to continuously improve data analysis skills
Requirements:
- Open to relocation
- BI Tools: SSIS, SSMS, SSRS, SSAS, power pivot, Power Query, Power BI, Alteryx (don't need all, more the better)
- Strong SQL Server
- Strong data modeling - 3nf, Erwin, dimensional modeling
- Data warehousing
- Data management / data quality
Candidate Profile:
* 7 years overall IT experience
* Minimum of 3-5 years of experience in Data Solution delivery in a complex environment working collaboratively in a team setting
* Proficient in Data Solution tools and concepts such as:
o Business Intelligence tools: Microsoft tools (SQL Server Management Studio, SSRS, SSAS, Power Pivot, Power Query, PowerBI), Alteryx
o Database: SQL Server
o Data Query tools: SQL, T-SQL
o Data Management and Quality: data mapping, data profiling, metadata repository, relational data modeling, master data management
o Data Modeling: ER/Studio Data Architect, 3NF and dimensional modeling
o Data Warehousing concepts: Inmon, Kimball, Data Lake
o Data Integration concepts and strategies: EII, ETL, EL-T and EAI
Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.
Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.
Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.
Salary : $60 - $75
