Data Engineer (SQL Server, Power BI, SSIS, SSRS)

About your future team Nexient is on a mission: To rid the world of crappy software, one sprint at a time.  Every day, our 1000+ Agile developers, designers, and strategists empower each other to find passion in our work while we innovate the world. This culture of teamwork and curiosity is fueled by a product-minded approach to our work, crafting extraordinary custom software solutions and growing careers along the way. Our clients range from some of America’s favorite brands in retail, healthcare, financial services to fast-emerging disruptors – You might have read about us in the NY Times. We’re also recognized as a Gartner Cool Vendor, HFS Hot Vendor, and America’s leading 100% U.S. Agile software services partner.  If you’re looking to change the trajectory of your career, make an impact on Day One, develop custom software on the best technology around – and maybe even make people’s lives easier -- then you belong here, with us. 

Role and Responsibilities:

• This data engineer should have exceptional SQL Server programming skills as follows
• Needs to have advanced Business Intelligence experience
• BIML scripting
• SSIS, SSRS, SSAS
• Power BI
• Excellent Leadership and communication skills
• Optional - .Net Application development
• Optional - Web (Angular) application development
• Should be able to mentor other developers in terms of processes and practices
• Should be able to troubleshoot and remediate performance issues
• Should have good data modelling concepts
• Extensive experience with reporting using Power BI
• Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
• Design and develop ETL Processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases
• In-depth knowledge of standard concepts, practices and procedures related to database management
• Experience coding complex stored procedures (using T-SQL)
• Experience with developing SSIS packages
• Proven analytical problem solving and debugging skills
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
• Providing database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments
• Design and develop enterprise and departmental business intelligence and data warehousing solutions
• Performs ad-hoc analysis using T-SQL query language within the database systems using a process-oriented approach
• Understands the concept of Data marts and Data lakes and experience with migrating legacy systems to data marts/lake
• Uses additional cloud technologies (e.g. understands concept of Cloud services like Azure SQL server)
• Uses SQL Server Analysis Services to enhance existing, or develop new, OLAP cubes used in the EDW system
• Uses Multi-Dimensional Expression (MDX) query language to extract data from OLAP cubes for reporting and analytical purposes

Why Nexient As a vital member of our Engineering Practice, you will be part of one of our 100+ small cross-functional teams working side by side with some of the most talented developers, UX designers, analysts, quality engineers, and product managers out there.  From Silicon Valley to Ann Arbor, Columbus, and beyond – a career with Nexient will offer you: Remote, hybrid, or onsite opportunities: Here, you decide the work arrangement that best suits your needs and preferences. Fulfilling and challenging projects: You will be exposed to different scenarios, multiple types of clients, and the most complex business and technology initiatives. Access to the most cutting-edge technologies: You’re always going to be advancing your skillset by learning and working with the newest and most relevant technologies available out there. A positive and passionate culture: Boring and divided aren’t in our vocabulary. In fact, it’s amazing to see how, despite our exponential growth, the Nexient culture and community stay as warm, diverse, and close as ever. Plenty of opportunities for you to explore and grow: We will empower you to dream as big as you want and support you to make your career what YOU want it to be. Creative runway: We take pride in encouraging our people to question the status quo.  Our benefits program includes: ·       Medical, dental, and vision coverage·       Generous PTO, plus holidays·       401(k) plan·       Life insurance and short-term & long-term disability·       Maternity leave·       Employee Assistance Program·       Flexible spending accounts·       Health savings account Nexient is an inclusive, equal opportunity employer. At Nexient, your uniqueness makes us better. Your uniqueness is why you are valued, you are heard, you add to our culture, and you belong. Diversity & Inclusion is hardcoded into our DNA and at the core of everything we do. Together, not separately, we strive to become even more diverse to help fuel our innovation and connect us closer with the clients and communities we serve.