Requisition: 2024-144260
SR ENTERPRISE DATA SYS DEV
Job Locations
US-CO-DENVER
ID
2024-144260
Line of Business
Amerita
Position Type
Full-Time
Pay Min
USD $119,100.00/Yr.
Pay Max
USD $178,700.00/Yr.
Our Company
Amerita
Overview
The Senior Enterprise Data System Developer is a highly skilled and
experienced Sr. Microsoft SQL Developer and Data Analyst. The Senior
Enterprise Data System Developer will be responsible for the development,
implementation, maintenance, and optimization of our Microsoft SQL Server
databases. The Senior Enterprise Data System Developer will play a critical
role in ensuring the integrity, security, and performance of our database
systems while collaborating closely with development teams and business
stakeholders to support and design custom datasets for our organizational
objec
* High-quality, affordable benefits for all Full-time and Part-time Employees
* Medical, Dental & Vision Benefits plus, HSA & FSA Savings Accounts
* Supplemental Coverage - Accident, Critical Illness and Hospital Indemnity
Insurance
* 401(k) Retirement Plan with Employer Match
* Company paid Life and AD&D Insurance, Short-Term and Long-Term Disability
* Employee Discounts
* Tuition Reimbursement
* Paid Time Off & Holidays
*Position will be posted for a minimum of 7 business days
Responsibilities
Designs, develops, and implements Microsoft SQL Server databases,
tables, views, stored procedures, and functions to support business
requirement
Designs, develops, and implements Microsoft SQL Server databases optimized
for seamless integration with PowerBI reporting and analytics tools
Collaborates with business analysts and developers to understand reporting
requirements and translate them into database schemas, queries, and stored
procedures to create reliable single source of truth datasets
Optimizes database performance through efficient indexing, query
optimization, and other tuning techniques
Implements data models, relationships, and calculations within the
database to support dynamic reporting capabilities in PowerBI
Supports migration of current reporting stack away from Microsoft Excel and
into a visualization platform. (e.g.: PowerBI)
Qualifications
Bachelor's degree in Computer Science, Information Technology, or
related field (or equivalent experience).
10+ years of proven experience as a Microsoft SQL Developer, Analyst,
and Database Administrator, with a strong understanding of database
concepts, architecture, and best practices.
Proficiency in T-SQL programming, including writing complex queries,
stored procedures, triggers, and functions.
Experience in designing, developing, and maintaining ETL processes for
data integration between various systems and databases. Familiarity with ETL
tools like SSIS (SQL Server Integration Services) or other similar tools.
Experience working in regulated industries (e.g., healthcare, finance)
with compliance requirements.
SQL Server Reporting Services (SSRS): Familiarity with creating and
managing reports using SSRS.
Proficiency in version control systems like Git and experience with
implementing DevOps practices for database development and deployment.
Familiarity with continuous integration/continuous deployment (CI/CD)
pipelines for database changes.
Experience in designing and developing complex reports and data analysis
solutions using tools like SQL Server Reporting Services (SSRS), Power
BI, or Tableau.
Proficiency in Microsoft SQL Server: This includes knowledge of SQL Server
Management Studio (SSMS), Transact-SQL (T-SQL), and SQL Server
Integration Services (SSIS).
Strong problem-solving skills and attention to detail to ensure data accuracy
and consistency across all reporting formats. (e.g.: Excel, PowerBI)
Ability to work with an entrepreneurial mindset, independently, focus with
high attention to detail, and in a team environment.
Adaptability and willingness to lear new technologies and best practices in
database development.
Knowledge of data visualization best practices.
Excellent analytical and problem-solving skills, with the ability to
troubleshoot database issues and implement effective... For full info follow
application link.