SQL BI Developer


Apply Now

Overview


Does working alongside business intelligence professionals, creating positive change, and providing business insights sound exciting to you? Join a team who will leverage your data modelling experience to design, package, and deploy data to further develop our BI architecture to answer existing and future business questions. Your talent and expertise in creating BI solutions will be critical in supporting the business functions within Educational Services to continue building on our successes.

Responsibilities


  • Work closely with subject matter experts and report developers to gain a deep understanding of business processes and reporting needs and translate them into data requirements
  • Collaborate with data owners and the enterprise data management team to implement new data sources required to support Educational Services reporting, decision support, and analytics needs
  • Integrate source data using various connection methods (APIs, flat files, databases)
  • Ensure that data structures follow enterprise data guidelines and security policies
  • Model the data into star schema tables focused on business processes using extract, transform, and load (ETL) processes, designed to address current and future business needs
  • Create/modify Power BI datasets and provide guidance to report developers concerning data access and optimal use in BI solutions
  • Monitor ETL jobs and prioritize resolution of issues to ensure data integrity and accuracy, based on customer impacts
  • Perform data quality checks to ensure consistency
  • Be the data management expert within the Educational Services BI team by understanding and documenting data elements, data models, dependences, and relationships
  • Work as part of the Educational Services BI team to maintain and develop components of the BI platform
  • Recognize opportunities for code and module reuse

Requirements


  • 5+ years of practical experience with SQL Server development (versions 2012 and higher)
  • 3+ years of practical experience with ETL development with SSIS, including creating integrations with external data sources
  • 3+ years of practical experience with Star Schema data modeling
  • Proven ability to develop complex SQL queries and stored procedures, designing efficient ETL processes, and writing performant SQL queries
  • Experience creating API integrations using C# and/or Python
  • Experience with Power BI or similar tool creating datasets and using DAX
  • Think analytically when data sourcing and resolve discrepancies that may arise from multiple business processes across multiple data subject areas
  • Possess an outstanding ability to clearly communicate data, context, and implications to business and technology stakeholders
  • Demonstrate clarity, depth, and creativity when problem solving
  • Ability to work cooperatively as part of a team, as well as independently under own initiative
  • Proven experience with data management including governance, data modeling, mapping
  • Bachelor’s in computer science or related field, or relevant work experience

Recommended Qualifications


  • Development experience with MongoDB
  • Background in a software-oriented environment

About Esri


Our passion for improving quality of life through geography is at the heart of everything we do. Esri’s geographic information system (GIS) technology inspires and enables governments, universities, and businesses worldwide to save money, lives, and our environment through a deeper understanding of the changing world around them.


Carefully managed growth and zero debt give Esri stability that is uncommon in today's volatile business world. Privately held, we offer exceptional benefits, competitive salaries, 401(k) and profit-sharing programs, opportunities for personal and professional growth, and much more.


Esri is an equal opportunity employer (EOE) and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.


If you need a reasonable accommodation for any part of the employment process, please email humanresources@esri.com and let us know the nature of your request and your contact information. Please note that only those inquiries concerning a request for reasonable accommodation will be responded to from this e-mail address.

#LI-SM1

Apply Now