Careers
American Traffic Solutions, Inc. (ATS) is a Scottsdale, Arizona-based technology and services company offering business solutions to support the growing worldwide requirements of our customers in the traffic and transportation management industry. www.atsol.com
BI Developer
Job Overview
We are currently hiring a Business Intelligence Developer in Scottsdale, AZ. This position will require a detail oriented individual with a Business Intelligence/Data Warehouse development background. The desired candidate will possess excellent communication and technical skills, as this position will require competence from cradle to grave within the Business Intelligence development process. This position will report directly to the Director of Database Services and Business Intelligence.
Responsibilities
 |
Work with end users to conceptualize/design/document the components of an Enterprise Data Warehouse. |
 |
Develop ETL processes, Analytical cubes, Dashboards, etc, utilizing the Microsoft suite of Business Intelligence products. |
Core Competencies
 |
Ability to understand and document business processes |
 |
Ability to work in a team environment |
 |
Ability to learn quickly |
 |
Ability to effectively communicate with all levels of the organization (developers, executives, etc) |
 |
Strong Experience with SQL |
 |
Strong troubleshooting skills |
 |
Strong organizational skills |
 |
Strong verbal and written communication skills |
 |
Strong database skills |
 |
Ability to communicate both the big picture as well as the process details in a visual format |
 |
Able to prioritize projects |
 |
Able to problem solve independently as well as part of a team |
 |
Inquisitive, with a desire to learn and be a contributor to business solutions that achieve the company’s goal of operational excellence |
 |
Recognize when a sense of urgency is needed |
 |
Demonstrated ability to multi-task and meet all assigned deadlines in a rapidly changing and high pressure environment |
 |
Business oriented, having a good understanding of basic business principles and operations |
 |
Demonstrated ability to change rapidly and often with an open mind |
 |
Professionalism and the ability to work well with different groups of people are important |
Experience Required:
 |
2 years experience with T-SQL |
 |
2 years experience with SQL Databases – SQL 2005 or SQL 2008 |
 |
2 year experience with Reporting Services |
 |
2 years experience with Visual Studio |
 |
2 years experience in effectively designing/publishing/testing reports/dashboards via SharePoint |
 |
2 years experience in data validation techniques |
 |
2 years experience with Analytical Cube design |
 |
2 years experience developing/tuning business intelligence and reporting solutions |
 |
2 years experience with documenting business requirements |
 |
2 years Business Intelligence Analysis and implementation skills |
 |
2 years experience in a Microsoft-based Business Intelligence environment |
Experience Desired:
 |
Exposure to software development methodologies |
 |
High energy level and a willingness to go the extra mile |
 |
Ability to work effectively under pressure to meet deadlines |
Work Environment
Job may require local travel, to the offices within the Phoenix metropolitan area.
To apply, please submit the following information to: Opportunities@Atsol.com.
 |
Cover letter stating how your skills match the requirements |
 |
Your resume with current contact information |
 |
A summary of your salary history |
 |
Your present salary requirements |
top | back to careers |