Senior Business Intelligence Developer
Formerly known as VISANOW, Envoy was founded in Chicago in 1998 to help people
navigate the stressful, confusing and incredibly inefficient immigration and visa application process. We built our company on a simple idea: never, ever forget that behind all the applications and case files there are people. We truly care about those people — their hopes, their dreams, their fears — and helping them realize what’s possible. Not only are we passionate about immigration, we’re passionate about our people. We are hiring smart, driven individuals who want to work hard and have fun doing it. We’re the leader in our space and backed by one of the country’s leading venture capital firms.
Main responsibilities:
- Responsible for designing, developing, and maintaining data
- warehouse and analytics architecture
- Create reports in SSRS as well as develop underlying T-SQL logic
- Implement and maintain dashboards and analytics
- Review, analyze, modify, and create ETLs, utilizing SSIS, testing,
- debugging, integration and implementation processes
- Maintain ETL and supporting data objects for our growing BI infrastructure
- Carry out monitoring, tuning, and database performance analysis
Minimum requirements:
- Bachelor's in Computer Science or a related field (hands-on
- experience trumps)
- 5+ years of experience as a database engineer or a related role
- Strong ETL and SQL experience, as well as with newer ones
- like SSIS, SSRS, data objects, and stored procedures
- Data warehouse experience
- Experience doing the Import/Export of metadata, Schemas, DB
- objects between environments (Dev/Test/Prod)
- Demonstrated ability to write SQL/TSQL queries to retrieve/modify
- data
- Knowledge and know-how to troubleshoot potential issues, and
- experience with best practices around database operations
- Ability to work in an Agile environment
- Salesforce (SOQL) experience
- Experience with visualization tools such as tableau, SportFire,
- TIBCO, QlikView, MicroStrategy, Information Builders, and other reporting and
- analytical tools is a plus
Why Envoy:
- Extremely competitive benefits plan including BCBS medical coverage, FREE
- employee dental and vision coverage, and a company-matched 401k plan that vests immediately
- Stock options after one year of employment
- 15 days of paid time off (PTO) and 9 paid holidays per year
- Casual work environment
- Company sponsored lunches, happy hours and events throughout the year
- Hands on training and career development opportunities
- Moxie Award Winner for Best Service Provider in 2015 and Most Disruptive Startup in 2016
- Rated as one of the top 50 employers for Gen Y Emerging Talent in Chicago
- Opportunity to work for an organization that changes lives every day
Envoy Global is an equal
opportunity employer regardless of race, color, religion, creed, sex, marital
status, national origin, disability, age, veteran status, on-the-job injury,
sexual orientation, political affiliation or belief.
EOE AA M/F/Vet/Disability