Current Statistics
1,637,792 Total Jobs 258,334 Jobs Today 17,876 Cities 222,695 Job Seekers 146,726 Resumes |
|
|
|
|
|
|
Analyst, Data & Reporting - Salem Oregon
Company: SitusAMC Location: Salem, Oregon
Posted On: 04/30/2024
SitusAMC is where the best and most passionate people come to transform our client's businesses and their own careers. Whether you're a real estate veteran, a passionate technologist, or looking to get your start, join us as we work together to realize opportunities for everyone, we proudly serve. At SitusAMC, we are looking to match your unique experience with one of our amazing careers, so that we can help you realize your potential and career growth within the Real Estate Industry. If you are someone who can be yourself, advocate for others, stay nimble, dream big, own every outcome, and think global but act local - come join our team! Primarily responsible for working with business users to create reports and dashboards. Essential Job Functions: -
Create complex t-SQL statements and stored procedures and queries to extract data from operational systems -
Build reports and data extracts -
Design and build visualizations and dashboards -
Work with Subject matter experts to define reporting and business intelligence requirements -
Mentor, review, improve and ensure the quality of work of junior analysts -
Release approved reports/stored procedures/dashboards to production and assist in operational release cycles -
Develop ETL processes to import data into reporting and business intelligence architecture -
Build data validations to ensure the quality of data and reporting -
Other activities as may be assigned by your manager Qualifications/ Requirements: -
Four year college degree or equivalent level of education and experience -
Proficient with Excel and Microsoft Office Suite -
1-2 years of residential or commercial mortgage experience -
3-5 years' experience building t-SQL statements, MySQL preferred -
1-2 years working with a business intelligence tool, Tableau experience highly desirable -
Proficient with SQL Server Reporting Services -
Experience with ETL tools desirable, SSIS preferred -
Strong communication (written and oral) skills -
Strong analytical ability, good judgment, strategic and multidimensional thinker -
Detail oriented and organized -
Strong commitment and dedication to the position and a Team Player Special Requirements: - The employee may be required to report to a different local office as a normal, contemplated, and mandated incident of their employment
Working Conditions: |
|
|
|
|
|
|