Build fast, reliable, transparent, and scalable business-focused information systems
Design and build standardized ETL processes to populate the data warehouse and feed stakeholders and business partners
Design, build, enhance, and maintain fault-tolerant batch-based and real-time ETL processes
Design and build data warehouses, data lakes, and data marts for structured and semi-structured data access
Design, build, enhance, and maintain Power BI and SSRS reports and dashboards from specs or user interaction
Automate manual data processes and optimize user queries
Decipher existing reports and database processes to assist users, analysts, and data stewards
Set up internal and external secure data exchanges using industry-standard encryption techniques
Implement data security measures to protect PII and other sensitive information
Integrate processes and tools to monitor and improve data quality and system stability per data governance
Complete work with emphasis on efficiency, quality, and maintainability
Requirements
Minimum of bachelor’s degree required
Professional or educational experience in ETL, Business Intelligence, or Statistical Analytics required
Strong understanding of SQL including basic joins, inserts, updates, deletes, conditional logic, subqueries, temp tables, and data transformation functions
Proficient knowledge of relational database management systems required
Experience reviewing datasets for data quality required
Experience with un- or semi-structured data (ex. XML, JSON) preferred
Experience with any data integration tool preferred
Experience with reporting platform like Power BI and SSRS preferred
Experience with different data security algorithms preferred
Intrinsically motivated with demonstrated ability to take initiative and implement improvements
Strong verbal and written communication skills
Team player able to adapt in a fast paced and changing environment
Commitment to exemplifying the organizational core values and key competencies
Exempt position with generally flexible schedule Monday-Friday between 8:00am-6:00pm, minimum expectation of 40 hours per week
Significant portions of daily assignments involve manual skills requiring motor coordination and finger dexterity
Ability to remain stationary up to 100% of the workday and constantly operate a computer and other standard office equipment
Job functions involve sedentary to light physical effort; may exert up to 10 pounds of force
Position does not require travel, though travel opportunities may arise
Benefits
Competitive base pay and performance bonuses, dependent on role