Job details
Job type full-time
Full job description
***update: moving forward and not limited to 2021, nexient will be supporting fully remote and hybrid work models for all team members*** we’re happy to announce that as part of our efforts to embrace, adapt, and provide more flexibility to our team members—nexient will be adopting a new set of work modelsWhether it’s fully remote, hybrid, or full-time at the office—you now have the option to choose the work arrangement that best suits your needs and preferencesYou are not locked into any selection and can make changes at any point if needed.
Don’t only dream about what’s next – come build it with us!
Nexient specializes in bringing a “product mindset” to our work, using small, nimble teams, agile thinking and other techniques from product development to build great custom software people love to use.
And as america’s leading 100% us, 100% agile software services partner, we’re building it here instead of sending tech jobs offshore.
People are noticing.
Our clients include some of america’s favorite brands in retail, healthcare, financial services and more – but also some very cool product companies you may not have heard of yetWe’re recognized as a gartner cool vendor, hfs hot vendor and the only 100% us tech company in the world’s top 100 outsourcersYou might have read about us in the new york times.
Nexient combines:
Silicon valley innovation (through our bay area innovation hub, and network of startups and emerging technology partners)
Scalable, midwest delivery (with 100+ agile teams in high talent cities like ann arbor, michigan)
Onsite collaboration (with product managers and other key roles working face-to-face with client teams around the country)
Come build with us!
Roles 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.gUnderstands 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.
Benefits & perks:
Company sponsored health, dental, vision insurance and flexible spending account (fsa) for employees and their families including domestic partners
Paid vacation time and company holidays
401k plan
Lunch & learn
Passionate, collaborative and awesome co-workers
World class training and career mentorship
Nexient is an inclusive equal opportunity employerAt nexient, your uniqueness makes us betterYour uniqueness is why you are valued, you are heard, you add to our culture, and you belongDiversity & inclusion is hard coded into our dna, and at the core of everything we doTogether, 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.
